--gimme a list of custom plugins
select * from EntityPlugIn p
where classname not in
('Aptify.Framework.BusinessLogic.Views.AptifyViewsEntity'
,'Aptify.Framework.WindowsForms.ViewsViewerForm'
,'Aptify.Framework.BusinessLogic.Entity.EntitiesEntity'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityViewerForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFieldForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityRelationshipForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityDatabaseObjectForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFieldValueForm'
,'Aptify.Framework.BusinessLogic.DBObject.DatabaseObjectEntity'
,'Aptify.Framework.WindowsForms.DatabaseObjectsViewerForm'
,'Aptify.Framework.WindowsForms.DBObjectRequirementViewerForm'
,'Aptify.Framework.BusinessLogic.Entity.EntityUserPermissionsEntity'
,'Aptify.Framework.WindowsForms.EntitiesViewer.UserPermissionsForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.GroupPermissionsForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityRequirementForm'
,'Aptify.Framework.BusinessLogic.Entity.EntityBulkOperationsViewer'
,'Aptify.Framework.BusinessLogic.Entity.EntityBulkOperationRulesViewer'
,'Aptify.Framework.BusinessLogic.Entity.EntityBulkOperationGroupPermissionsViewer'
,'Aptify.Framework.BusinessLogic.Entity.EntityBulkOperationUserPermissionsViewer'
,'Aptify.Framework.BusinessLogic.Entity.EventHandlerRecordsViewer'
,'Aptify.Framework.BusinessLogic.Entity.FormTemplatesViewer'
,'Aptify.Framework.BusinessLogic.Entity.FormTemplatesEntity'
,'Aptify.Framework.BusinessLogic.Entity.FormTemplatePartsViewer'
,'Aptify.Framework.BusinessLogic.Entity.BaseFieldsEntity'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFieldForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFieldValueForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFieldGroupPermission'
,'Aptify.Framework.WindowsForms.ScheduledTasksViewer'
,'Aptify.Framework.BusinessLogic.ScheduledTasks.ScheduledTasksEntity'
,'Aptify.Framework.BusinessLogic.AptifyGroupsEntity'
,'Aptify.Framework.BusinessLogic.AptifyUsersEntity'
,'Aptify.Framework.WindowsForms.UsersViewer'
,'Aptify.Framework.WindowsForms.UserEntityRelationUI'
,'Aptify.Framework.WindowsForms.ObjectPackagesViewerForm'
,'Aptify.Framework.BusinessLogic.ObjectRepositoryObjectsEntity'
,'Aptify.Framework.WindowsForms.ObjectRepositoryObjectsViewerForm'
,'Aptify.Framework.Archive.ArchiveRunViewer'
,'Aptify.Framework.Archive.ArchiveEntity'
,'Aptify.Framework.BusinessLogic.Entity.TopicCodesEntity'
,'Aptify.Framework.BusinessLogic.Entity.TopicCodeLinksEntity'
,'Aptify.Framework.BusinessLogic.Entity.EntityConstraintsEntity'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityConstraintsViewerForm'
,'Aptify.Framework.BusinessLogic.Entity.EntityFieldsEntity'
,'Aptify.Framework.Messaging.MessageRunsEntity'
,'Aptify.Framework.BusinessLogic.Entity.EventDefinitionsViewer'
,'Aptify.Framework.WindowsForms.EntitiesViewer.EntityFieldUserPermission'
,'Aptify.Framework.BusinessLogic.ProcessPipeline.WindowsControl.ProcessFlowEditorForm'
,'Aptify.Framework.BusinessLogic.Packers.PackLoadersEntity'
,'Aptify.Framework.BusinessLogic.PendingChanges.PendingChangesViewer'
,'Aptify.Framework.BusinessLogic.PendingChanges.PendingChangesEntity'
,'Aptify.Applications.Campaigns.Campaign'
,'Aptify.Applications.Campaigns.CampaignList'
,'Aptify.Applications.Campaigns.CampaignDocObject'
,'Aptify.Applications.ContactManagement.ContactLog'
,'Aptify.Applications.Inventory.InventoryLocationObject'
,'Aptify.Applications.ProductSetup.ProductCategory'
,'Aptify.Applications.Inventory.ProductInventoryLedgerEntry'
,'Aptify.Framework.BusinessLogic.Entity.Employees.EmployeesEntity'
,'Aptify.Applications.Accounting.ScheduledTransaction'
,'Aptify.Applications.Tasks.TasksEntity'
,'Aptify.Applications.Accounting.StandingOrdersEntity'
,'Aptify.Framework.BusinessLogic.DuplicateProcessing.DuplicateViewer'
,'Aptify.Framework.BusinessLogic.DuplicateProcessing.DupeEntity'
,'Aptify.Applications.CompanyObject.CompanyObject'
,'Aptify.Applications.Subscriptions.SubscriptionRenewal'
,'Aptify.Applications.Organization.OrganizationObject'
,'Aptify.Applications.Persons.PersonExtension'
,'Aptify.Applications.Persons.PersonsEntity'
,'Aptify.Applications.Accounting.ScheduledTransactionGroupsExtension'
,'Aptify.Applications.Accounting.ScheduleTransactionExtension'
,'Aptify.Applications.Accounting.BatchViewerForm'
,'Aptify.Applications.Accounting.Batch'
,'Aptify.Applications.ProductSetup.ProductObject'
,'Aptify.Applications.ProductSetup.ProductPriceObject'
,'Aptify.Framework.Replication.PublicationEntitiesEntity'
,'Aptify.Applications.ExpoManagement.FloorplanViewerForm'
,'Aptify.Applications.ExpoManagement.Floorplan'
,'Aptify.Applications.Accounting.PaymentInformation'
,'Aptify.Applications.OrderEntry.Payments.PaymentsEntity'
,'Aptify.Applications.Persons.PersonCompaniesEntity'
,'Aptify.Applications.OrderEntry.CheckInventory'
,'Aptify.Applications.ProductSetup.ProductPrice'
,'Aptify.Applications.OrderEntry.Subscriptions.SubscriptionDate'
,'Aptify.Applications.OrderEntry.Subscriptions.SubscriptionSave'
,'Aptify.Applications.OrderEntry.OrderExtraPayment'
,'Aptify.Applications.OrderEntry.OrderAddressFlowdown'
,'Aptify.Applications.Accounting.Currency.CurrencyMarkToMarket'
,'Aptify.Applications.OrderEntry.BackOrders'
,'Aptify.Applications.OrderEntry.LineShipDialog'
,'Aptify.Applications.OrderEntry.Payments.PaymentGenerateGL'
,'Aptify.Applications.OrderEntry.Payments.Extension'
,'Aptify.Applications.OrderEntry.CheckCredit'
,'Aptify.Applications.Accounting.Currency.RetrieveSpotRate'
,'Aptify.Applications.OrderEntry.OrderGenerateGL'
,'Aptify.Applications.OrderEntry.OrdersEntity'
,'Aptify.Applications.OrderEntry.OrderLinesEntity'
,'Aptify.Applications.CRM.PreferredAddress'
,'Aptify.Applications.Campaigns.CampaignCalculateDiscount'
,'Aptify.Applications.OrderEntry.GenerateCOGS'
,'Aptify.Applications.OrderEntry.OrdersExtension'
,'Aptify.Applications.Accounting.SalesTax'
,'Aptify.Applications.Persons.PersonSPMEntity'
,'Aptify.Applications.CompanyObject.CompanySPMEntity'
,'Aptify.Applications.Accounting.SalesTaxRateEntity'
,'Aptify.Framework.BusinessLogic.FilterRules.FilterRulesEntity'
,'Aptify.Applications.OrderEntry.ShippingCalculator'
,'Aptify.Framework.Licensing.UserLicenseAssignmentObject'
,'Aptify.Framework.WindowsControls.PivotTableLinkedEntityViewer'
,'Aptify.Applications.OrderEntry.OrderMeetingDetailEntity'
,'Aptify.Applications.MeetingManagement.MeetingsEntity'
,'Aptify.Applications.OrderEntry.OrderBoothDetailEntity'
,'Aptify.Applications.OrderEntry.ShipmentTypeGroupingsEntity'
,'Aptify.Applications.OrderEntry.ShipmentTypeMatrixEntity'
,'Aptify.Applications.OrderEntry.OrderShipmentsEntity'
,'Aptify.Applications.Housing.Housing'
,'Aptify.Applications.Housing.HousingBlock'
,'Aptify.Applications.Housing.HousingBlockRoom'
,'Aptify.Applications.Housing.HousingReservationDetail'
,'Aptify.Applications.Housing.HousingReservation'
,'Aptify.Applications.Housing.HousingReservationGuest'
,'Aptify.Applications.OrderEntry.RelatedProducts'
,'Aptify.Applications.OrderEntry.RelatedProductsForm'
,'Aptify.Applications.OrderEntry.ExpandKits'
,'Aptify.Applications.ProductSetup.ProductPartsEntity'
,'Aptify.Applications.ExpoManagement.Booths'
,'Aptify.Applications.Subscriptions.SubscriptionFulfillmentsEntity'
,'Aptify.Applications.Accounting.GreatPlainsExport'
,'Aptify.Applications.ExpoManagement.Booth'
,'Aptify.Framework.BusinessLogic.ProcessPipeline.ProcessFlowsEntity'
,'Aptify.Applications.OrderEntry.BulkOrdersGE'
,'Aptify.Applications.Notes.NotesEntity'
,'Aptify.Framework.GenericWizard.WizardPage'
,'Aptify.Applications.CommitteeTerm.CommitteeTermsEntity'
,'Aptify.Applications.CommiteeTerm.CommiteeTermMemberEntity'
,'Aptify.Applications.OrderEntry.Payments.PaymentLinesEntity'
,'Aptify.Applications.Chapters.ChapterAssignmentRules'
,'Aptify.Applications.MemberTypes.MemberTypesEntity'
,'Aptify.Applications.Commissions.CommisionPlanEntity'
,'Aptify.Applications.Commissions.CommissionBaseFormula'
,'Aptify.Applications.Commissions.CommissionBaseFormulaViewer'
,'Aptify.Applications.Commissions.CommissionAgreement'
,'Aptify.Applications.Commissions.CommissionPlanItemsEntity'
,'Aptify.Applications.Commissions.CommissionRateScale'
,'Aptify.Applications.Commissions.CommissionAgreementDetail'
,'Aptify.Applications.Commissions.CommissionPayment'
,'Aptify.Applications.Commissions.CommissionPaymentViewer'
,'Aptify.Applications.Commissions.CommissioniPayDetailsEntity'
,'Aptify.Applications.Advertising.AdvertisingContract'
,'Aptify.Applications.Advertising.AdvertisingRateCardDeadlineEntity'
,'Aptify.Applications.Advertising.AdvertisingUnitDefinition'
,'Aptify.Applications.Advertising.AdvertisingRateCardRate'
,'Aptify.Applications.Advertising.AdvertisingOption'
,'Aptify.Applications.Advertising.AdvertisingRateCardRateOption'
,'Aptify.Applications.Advertising.AdvertisingInsertionOrder'
,'Aptify.Framework.BusinessLogic.Spelling.MSWordSpell'
,'Aptify.Applications.Fundraising.Pledge'
,'Aptify.Applications.Fundraising.PledgeMatchingObject'
,'Aptify.Applications.Fundraising.PledgePaymentSchedule'
,'Aptify.Applications.Fundraising.Grants'
,'Aptify.Applications.Fundraising.DonorAdvisedFundAllocation'
,'Aptify.Applications.Fundraising.Solicitor'
,'Aptify.Applications.Inventory.ProductInventoryLedger'
,'Aptify.Applications.Education.Exam'
,'Aptify.Applications.Education.ClassObject'
,'Aptify.Applications.Education.ClassRegistrationGE'
,'Aptify.Applications.Education.AnswerSheet'
,'Aptify.Framework.Web.eBusiness.LearningManagementSystems.LMSBase'
,'Aptify.Applications.Subscriptions.SubscriptionEntity'
,'Aptify.Framework.WindowsForms.EntitiesViewer.GroupAttachmentPermissionsForm'
,'Aptify.Framework.WindowsForms.EntitiesViewer.UserAttachmentPermissionsForm'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonAccountManagersClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonAddressClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonCompanyFunctionsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonEducationClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonFunctionsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonPhoneClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonRelationshipsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PersonTaxExemptCodesClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.CompanyAccountManagersClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.CompanyAddressClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.CompanyPhoneClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.CompanyProductCodesClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.CompanyRelationshipsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.CompanyTaxExemptCodesClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrganizationAddressesClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrganizationGLAccountsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrganizationInterCompanyGLClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.ContactLogLinksClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.EmployeeSkillsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.SubscriptionDeliveryLogClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.SubscriptionDeliveryScheduleClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.SubscriptionPurchasesClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PaymentAuthorizationsClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.PaymentGLEntryClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrderCurrencySpotRateClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrderGLEntryClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrderInvAllocationClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrderLineTaxesClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrderPaymentScheduleClass'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.OrderShipmentTaxesClass'
,'Aptify.Framework.ApplicationRibbonGroup.Components.RibbonGroupForm'
,'Aptify.Framework.ApplicationRibbonGroup.Components.ButtonForm'
,'Aptify.Framework.BusinessLogic.AttachmentCategories.AttachmentCategoryEntity'
,'Aptify.Framework.BusinessLogic.GenericEntity.Generated.ScheduledTransactionAccountEntriesClass'
,'Aptify.Framework.ApplicationRibbonGroup.Components.RibbonGroupButtonForm'
,'Aptify.Framework.ApplicationRibbonGroup.Components.RibbonButtonButton'
,'Aptify.Framework.WindowsControls.EntityRedirectViewerPlugIn'
,'Aptify.Applications.Marketplace.MarketplaceListingsEntity'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.Integration.CMSIntegrationGeneric'
,'Aptify.Framework.FullText.FullTextCatalogsEntity'
,'Aptify.Applications.OrderEntry.RelatedMeetingSession'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.FullText.FullTextIndexesEntity'
,'Aptify.Framework.FullText.FullTextIndexFieldsEntity'
,'Aptify.Applications.OrderEntry.RelatedMeetingSessionsForm'
,'Aptify.Framework.BusinessLogic.ViewCategoriesEntity'
,'Aptify.Applications.Accounting.AptifyTaxJurisdictionsEntity'
,'Aptify.Applications.Commissions.CommissionPayDetAdjustmentEntity'
,'Aptify.Applications.Fundraising.GrantDisbursements'
,'Aptify.Framework.DataPacker.AlertTypesDataPackPlugIn'
,'Aptify.Framework.DataPacker.ApplicationsDataPackPlugIn'
,'Aptify.Framework.DataPacker.ApplicationEntitiesDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.CultureStringsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.DashboardButtonsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.DashboardPartsDataPackPlugIn'
,'Aptify.Framework.DataPacker.EntityPlugInTypesDataPackPlugIn'
,'Aptify.Framework.DataPacker.FormTemplatePartsDataPackPlugIn'
,'Aptify.Framework.DataPacker.FormTemplatePartsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.FormTemplatesDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.MessagePartsDataPackPlugIn'
,'Aptify.Framework.DataPacker.MessagePartsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.ProcessFlowsDataPackPlugIn'
,'Aptify.Framework.DataPacker.ScriptsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.UsersDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.WizardsDataPackPlugIn'
,'Aptify.Framework.WindowsControls.ListDetailObject'
,'Aptify.Framework.WindowsControls.EntityRedirectViewerPlugIn'
,'Aptify.Framework.FormTemplate.AptifyFormTemplatePartEntity'
,'Aptify.Applications.Accounting.AccountingPeriodsEntity'
,'Aptify.Applications.MeetingManagement.MeetingStatusEntity'
,'Aptify.Framework.WindowsControls.EntityRedirectViewerPlugIn'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Applications.Fundraising.MatchRules'
,'Aptify.Framework.WindowsControls.EntityRedirectViewerPlugIn'
,'Aptify.Framework.WindowsControls.EntityRedirectViewerPlugIn'
,'Aptify.Framework.DataPacker.AlertTypesDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.ApplicationsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.DashboardsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.MessageTemplatesDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.ScriptTypesUnpackPlugIn'
,'Aptify.Framework.BusinessLogic.Entity.EntityBaseViewsEntity'
,'Aptify.Framework.BusinessLogic.Entity.EntityBaseViewsFields'
,'Aptify.Applications.OrderEntry.BulkOrderCustomers'
,'Aptify.Applications.Accounting.PaymentTypeObject'
,'Aptify.Applications.CRM.PersonDupeCheck'
,'Aptify.Security.Provider.TokenProvider.TokenProviderEntityPlugin'
,'Aptify.Framework.GenericImport.AptifyImportRunsEntity'
,'Aptify.Application.SpaceThreads.SpaceThreadsEntity'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.Web.eBusiness.Knowledge.QuestionTreeEntityBase'
,'Aptify.Framework.BusinessLogic.Security.SecurityKeysEntityObject'
,'Aptify.Framework.DataPacker.DashboardsDataPackPlugIn'
,'Aptify.Framework.DataPacker.EntityPlugInTypesDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.GroupsDataPackPlugIn'
,'Aptify.Framework.DataPacker.ProcessFlowsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.EntitiesDataPackPlugIn'
,'Aptify.Application.InventoryTransferEntity.InventoryTransfersEntity'
,'Aptify.Framework.DataPacker.WizardsDataPackPlugIn'
,'Aptify.Framework.BusinessLogic.Entity.EntityFullTextIndexFiltersEntity'
,'Aptify.Applications.MeetingManagement.MeetingRooms.MeetingRoomsEntity'
,'Aptify.Applications.MeetingManagement.MeetingRooms.MeetingRoomRoomsEntity'
,'Aptify.Applications.Fundraising.PledgeMatchObject'
,'Aptify.Applications.ProductSetup.ProductCostDetails'
,'Aptify.Applications.Education.CoursesEntity'
,'Aptify.Framework.DataPacker.EntityBulkOperationsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.WizardsDataUnpackPlugIn'
,'Aptify.Framework.BusinessLogic.Entity.EntityDefaultBaseViewsEntity'
,'Aptify.Framework.DataPacker.ViewsDataPackPlugIn'
,'Aptify.Framework.DataPacker.WizardsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.DashboardButtonsDataPackPlugIn'
,'Aptify.Framework.DataPacker.DashboardPartsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.EntityBulkOperationsDataPackPlugIn'
,'Aptify.Framework.DataPacker.FormTemplatesDataPackPlugIn'
,'Aptify.Framework.DataPacker.GroupsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.MessageTemplatesDataPackPlugIn'
,'Aptify.Framework.DataPacker.ProductsDataPackPlugIn'
,'Aptify.Framework.DataPacker.ViewsDataUnpackPlugIn'
,'Aptify.Framework.DataPacker.EntitiesDataUnpackPlugIn'
,'Aptify.Framework.WindowsControls.EntityRedirectViewerPlugIn'
,'Aptify.Applications.ProductSetup.ProductType')